ALTER TABLE Client_Customer
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
-----------------------------------------
ALTER TABLE item
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
------------------------------------------
ALTER TABLE so
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update so set dUpdated = dDate
GO
------------------------------------------
ALTER TABLE sales
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update sales set dUpdated = dDate
GO
------------------------------------------
ALTER TABLE AR
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update AR set dUpdated = dDate
GO
-----------------------------------------
ALTER TABLE PR
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update PR set dUpdated = dDate
GO
-----------------------------------------
ALTER TABLE dr
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update dr set dUpdated = dDate
GO
-----------------------------------------
ALTER TABLE PO
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update PO set dUpdated = dDate
GO
-----------------------------------------
ALTER TABLE purchase
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update purchase set dUpdated = dDate
GO
-----------------------------------------
ALTER TABLE ap
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update ap set dUpdated = dDate
GO
-----------------------------------------
ALTER TABLE VOUCHER
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update VOUCHER set dUpdated = dDate
GO
-----------------------------------------

ALTER TABLE CLEARED
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update CLEARED set dUpdated = dDate
GO
-----------------------------------------

ALTER TABLE ISSUED
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update ISSUED set dUpdated = dDate
GO
-----------------------------------------

ALTER TABLE PAYABLES
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update PAYABLES set dUpdated = dDate
GO
-----------------------------------------
ALTER TABLE WRR
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update WRR set dUpdated = dDate
GO
-----------------------------------------

ALTER TABLE INVADJ
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update INVADJ set dUpdated = dDate
GO
-----------------------------------------

ALTER TABLE TRANSFER
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update TRANSFER set dUpdated = dDate
GO
-----------------------------------------

ALTER TABLE PRODUCTION
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update PRODUCTION set dUpdated = dDate
GO


-----------------------------------------
ALTER TABLE GL
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update GL set dUpdated = dDate
GO

-----------------------------------------
ALTER TABLE intar
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update intar set dUpdated = dDate
GO


-----------------------------------------
ALTER TABLE FIXEDASSETDEPRE
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update FIXEDASSETDEPRE set dUpdated = dDate
GO

-----------------------------------------
ALTER TABLE deposit
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update deposit set dUpdated = dDate
GO

-----------------------------------------
ALTER TABLE PULLED
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update PULLED set dUpdated = dDate
GO


-----------------------------------------
ALTER TABLE replaced
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update replaced set dUpdated = dDate
GO


-----------------------------------------
ALTER TABLE BOUNCED
ADD dUpdated DATETIME NOT NULL DEFAULT ''
GO 
update BOUNCED set dUpdated = dDate
GO
